package com.cc.visitor.dao;

import com.cc.visitor.entity.Department;
import com.cc.visitor.entity.VisitSignatureFile;
import com.mybatisflex.core.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author chanchaw
 * @create 2025-01-21 13:49
 */
public interface VisitSignatureFileMapper extends BaseMapper<VisitSignatureFile> {
    @Select("select * from visit_signature_file where hash_string = #{hashString}")
    List<VisitSignatureFile> get8HashString(@Param("hashString")String hashString);
    @Select("select * from visit_signature_file where parent_id = #{parentId}")
    List<VisitSignatureFile> get8ParentId(@Param("parentId")Integer parentId);
}
